Previous Topic

Next Topic

STATE (Validation)

STATE is a validation-only table for the St/Prov field used in customer addresses, which comes preloaded with all 50 two-character abbreviations of the United States (with full name descriptions). It also contains valid codes for the District of Columbia, for Canadian provinces, and for some U.S. related regions. You can add any entries you need.

See Also

Reference to General Lookup/Validation Tables

ACCESS_KEYWORDS (Validation)

ADDRESS_PURPOSE (Validation)

APPEAL_TYPE (Validation)

BAD_ADDRESS (Validation)

BADGE_TYPES (Validation)

CATEGORY (Validation)

CEU_TYPE (Required Validation)

COMMITTEE_GROUP (Validation)

COMMITTEE_STS (Required Validation)

CONFLICT_CODE (Validation)

CONTACT_TYPE (Validation)

COUNTRY (Validation, Expansion)

DESIGNATION (Expansion only)

EXPENSE_TYPE (Validation, Expansion)

EXPO_CAT (Validation)

EXPO_PROD_CAT (Validation)

FUNC_TITLE (Validation)

FUNDRAISER_TYPE (Validation)

GL_ACCOUNT (Validation)

GROUP_CODE (Validation)

HOLD_CODES (Lookup only)

LOCATION (Lookup only)

MAIL_CODE (Lookup only)

MEETING_TYPE (Lookup only)

MEM_TRIB_RELATIONSHIP (Validation)

MEMBER_STATUS (Required Validation)

MERGE_CODE (Validation)

NOTE_PURPOSE (Validation)

PREFIX (Validation)

REFERRAL_AREA (Validation)

REQUEST_STATUS (Validation)

REQUEST_TYPE (Validation)

SALUTATION_CODE (Validation)

SHIP_METHOD (Required Validation)

SIC_CODE (Validation)

SOURCE_CODE (Validation)

SR_AREA (Validation)

SR_CAT (Validation)

SR_ENVIRON (Validation)

SR_CATLEVEL (Validation)

SR_CNTTYPE (Validation)

SR_RES (Required Validation)

SR_SRVTYPE (Required Validation)

SR_SYS (Validation)

SR_VERSION (Validation)

SUFFIX (Validation)

TITLE (Validation/Lookup)

ZIP3 (Validation)


ASI logo 10.6 Production Release. Updated 1/24/2006 3:12:42 PM
© Copyright by Advanced Solutions International, Inc. All rights reserved.